
package com.amigo.online.provider.video.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;

import com.amigo.online.common.core.mybatis.MyMapper;
import com.amigo.online.provider.video.model.entity.AdvArea;

/**
 * <code>AdvAreaMapper.java</code>
 * <p>
 *
 * </p>
 * <p>
 *
 * @author LuChen
 * @version 1.0
 * @company Amigo
 * @time 2018年11月19日 下午2:47:39
 * @lastUpdate 无
 * </p>
 */
@Mapper
@Component
public interface AdvAreaMapper extends MyMapper<AdvArea> {

    @Select("select * from adv_area_tbl where country_id = #{countryId} and deleted = 0")
    List<AdvArea> getAreaByCountryId(@Param("countryId") Long countryId);

}

